package com.J1ay.carsys.dao;

import com.J1ay.carsys.dto.LoginInput;
import com.J1ay.carsys.dto.LoginOutput;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * @Author J1ay
 * @Date 2021/6/2 22:17
 * @Description
 */

public interface EmpMapper {
    /**
     * @Author J1ay
     * @Date 2021/6/3 21:03
     * @param loginInput
     * @Description 登录验证 pwd--MD5
     * @return
     */

    @Select("SELECT * " +
            "FROM login " +
            "WHERE password = MD5(#{loginInput.password}) " +
            "AND username = #{loginInput.username}")
    LoginOutput EmpLoginByPwd(@Param("loginInput")LoginInput loginInput);
}
